*Paper: Fiscal Rules, Corruption and Electoral Accountability - Replication Files

clear all
cap log close 
set more off


**Global files
global folder "/Users/tommasogiommoni/Dropbox/Determinants of corruption/Stability pact and corruption/Replication files JOP"


********************************************************************************
****----						Dataset open 					    	----**** 
********************************************************************************

use "$folder/Data/TableA1.dta", clear

********************************************************************************
****----						Analysis 					    		----**** 
********************************************************************************

****---- All regions ----****

*Main variables
estpost sum corruption_PC corruption_exp_log corruption_max_PC corruption_max_exp corruption_abs_binary house_tax_ordinary current_exp_PC capital_ext_PC procurement_amount_PC  term_limit victory_margin high_education high_education_councillors av_age_Elected proportion_female_Elected
esttab using "$folder/Tables/TableA1_column_1_panels_A_B_C_D.tex", cells("mean") replace

*Data income declarations
estpost sum income_ACI_amount_PC diff_6_1_AvRevenues diff_6_12_AvRevenues
esttab using "$folder/Tables/TableA1_column_1_panel_E.tex", cells("mean") replace

*Municipal services
estpost sum kids_kindergarten kids_admitted   meals_offered_school canteen_school_admitted workers_kindergarten sport_structures share_light trash_share mun_workers
esttab using "$folder/Tables/TableA1_column_1_panel_F.tex", cells("mean") replace

****---- Dividing between FCRs/FURs ----****

*Main variables
estpost sum corruption_PC corruption_exp_log corruption_max_PC corruption_max_exp corruption_abs_binary house_tax_ordinary current_exp_PC capital_ext_PC procurement_amount_PC term_limit victory_margin high_education high_education_councillors av_age_Elected proportion_female_Elected if FURs==0
esttab using "$folder/Tables/TableA1_column_2_panels_A_B_C_D.tex", cells("mean") replace

estpost sum corruption_PC corruption_exp_log corruption_max_PC corruption_max_exp corruption_abs_binary house_tax_ordinary current_exp_PC capital_ext_PC procurement_amount_PC term_limit victory_margin high_education high_education_councillors av_age_Elected proportion_female_Elected if FURs==1
esttab using "$folder/Tables/TableA1_column_3_panels_A_B_C_D.tex", cells("mean") replace

*Data income declarations
estpost sum income_ACI_amount_PC diff_6_1_AvRevenues diff_6_12_AvRevenues if FURs==0
esttab using "$folder/Tables/TableA1_column_2_panel_E.tex", cells("mean") replace

estpost sum income_ACI_amount_PC diff_6_1_AvRevenues diff_6_12_AvRevenues if FURs==1
esttab using "$folder/Tables/TableA1_column_3_panel_E.tex", cells("mean") replace

*Municipal services
estpost sum kids_kindergarten kids_admitted   meals_offered_school canteen_school_admitted workers_kindergarten sport_structures share_light trash_share mun_workers if FURs==0
esttab using "$folder/Tables/TableA1_column_2_panel_F.tex", cells("mean") replace

estpost sum kids_kindergarten kids_admitted   meals_offered_school canteen_school_admitted workers_kindergarten sport_structures share_light trash_share mun_workers if FURs==1
esttab using "$folder/Tables/TableA1_column_3_panel_F.tex", cells("mean") replace
